2024-03-19 18:20:24,341 [ 274182 ] INFO : ClickHouse root is not set. Will use /home/ubuntu/_work/_temp/test/git-repo-copy (runner:41, check_args_and_update_paths) 2024-03-19 18:20:24,342 [ 274182 ] INFO : Cases dir is not set. Will use /home/ubuntu/_work/_temp/test/git-repo-copy/tests/integration (runner:89, check_args_and_update_paths) 2024-03-19 18:20:24,342 [ 274182 ] INFO : src dir is not set. Will use /home/ubuntu/_work/_temp/test/git-repo-copy/src (runner:96, check_args_and_update_paths) 2024-03-19 18:20:24,342 [ 274182 ] INFO : base_configs_dir: /home/ubuntu/_work/_temp/test/git-repo-copy/programs/server, binary: /home/ubuntu/_work/_temp/test/build/clickhouse, cases_dir: /home/ubuntu/_work/_temp/test/git-repo-copy/tests/integration (runner:98, check_args_and_update_paths) clickhouse_integration_tests_volume WARNING: Ignoring custom format, because both --format and --quiet are set. Running pytest container as: 'docker run --rm --name clickhouse_integration_tests_j9f2pp --privileged --volume=/home/ubuntu/_work/_temp/test/build/clickhouse-odbc-bridge:/clickhouse-odbc-bridge --volume=/home/ubuntu/_work/_temp/test/build/clickhouse:/clickhouse --volume=/home/ubuntu/_work/_temp/test/build/clickhouse-library-bridge:/clickhouse-library-bridge --volume=/home/ubuntu/_work/_temp/test/git-repo-copy/programs/server:/clickhouse-config --volume=/home/ubuntu/_work/_temp/test/git-repo-copy/tests/integration:/ClickHouse/tests/integration --volume=/home/ubuntu/_work/_temp/test/git-repo-copy/src/Server/grpc_protos:/ClickHouse/src/Server/grpc_protos --volume=/run:/run/host:ro --volume=clickhouse_integration_tests_volume:/var/lib/docker -e DOCKER_CLIENT_TIMEOUT=300 -e COMPOSE_HTTP_TIMEOUT=600 -e XTABLES_LOCKFILE=/run/host/xtables.lock -e PYTHONUNBUFFERED=1 -e DOCKER_DOTNET_CLIENT_TAG=0-0a8ac3b092733da37e3e2a0079c486938a36790d -e DOCKER_HELPER_TAG=0-0a8ac3b092733da37e3e2a0079c486938a36790d -e DOCKER_BASE_TAG=0-0a8ac3b092733da37e3e2a0079c486938a36790d -e DOCKER_KERBERIZED_HADOOP_TAG=0-0a8ac3b092733da37e3e2a0079c486938a36790d -e DOCKER_KERBEROS_KDC_TAG=0-0a8ac3b092733da37e3e2a0079c486938a36790d -e DOCKER_MYSQL_GOLANG_CLIENT_TAG=0-0a8ac3b092733da37e3e2a0079c486938a36790d -e DOCKER_MYSQL_JAVA_CLIENT_TAG=0-0a8ac3b092733da37e3e2a0079c486938a36790d -e DOCKER_MYSQL_JS_CLIENT_TAG=0-0a8ac3b092733da37e3e2a0079c486938a36790d -e DOCKER_MYSQL_PHP_CLIENT_TAG=0-0a8ac3b092733da37e3e2a0079c486938a36790d -e DOCKER_POSTGRESQL_JAVA_CLIENT_TAG=0-0a8ac3b092733da37e3e2a0079c486938a36790d -e PYTEST_OPTS='--dist=loadfile -n 10 -rfEps --run-id=0 --color=no --durations=0 test_storage_mysql/test.py::test_binary_type test_storage_mysql/test.py::test_enum_type test_storage_mysql/test.py::test_external_settings test_storage_mysql/test.py::test_insert_on_duplicate_select test_storage_mysql/test.py::test_insert_select test_storage_mysql/test.py::test_many_connections test_storage_mysql/test.py::test_mysql_distributed test_storage_mysql/test.py::test_mysql_in test_storage_mysql/test.py::test_mysql_null test_storage_mysql/test.py::test_predefined_connection_configuration test_storage_mysql/test.py::test_replace_select test_storage_mysql/test.py::test_settings test_storage_mysql/test.py::test_settings_connection_wait_timeout test_storage_mysql/test.py::test_table_function test_storage_mysql/test.py::test_where test_storage_policies/test.py::test_storage_policy_configuration_change test_table_function_mongodb/test.py::test_auth_source[False] test_table_function_mongodb/test.py::test_complex_data_type[False] test_table_function_mongodb/test.py::test_incorrect_data_type[False] test_table_function_mongodb/test.py::test_missing_columns[False] test_table_function_mongodb/test.py::test_no_credentials[False] test_table_function_mongodb/test.py::test_predefined_connection_configuration[False] test_table_function_mongodb/test.py::test_secure_connection[True] test_table_function_mongodb/test.py::test_simple_select[False] test_temporary_data_in_cache/test.py::test_cache_evicted_by_temporary_data -vvv' altinityinfra/integration-tests-runner:0-0a8ac3b092733da37e3e2a0079c486938a36790d '. Start tests ============================= test session starts ============================== platform linux -- Python 3.8.10, pytest-8.0.2, pluggy-1.4.0 -- /usr/bin/python3 cachedir: .pytest_cache rootdir: /ClickHouse/tests/integration configfile: pytest.ini plugins: repeat-0.9.3, xdist-3.5.0, random-0.2, timeout-2.2.0, order-1.0.0 timeout: 900.0s timeout method: signal timeout func_only: False created: 10/10 workers 10 workers [25 items] scheduling tests via LoadFileScheduling test_storage_policies/test.py::test_storage_policy_configuration_change test_storage_mysql/test.py::test_binary_type test_table_function_mongodb/test.py::test_auth_source[False] test_temporary_data_in_cache/test.py::test_cache_evicted_by_temporary_data [gw4] [ 4%] PASSED test_temporary_data_in_cache/test.py::test_cache_evicted_by_temporary_data [gw1] [ 8%] PASSED test_table_function_mongodb/test.py::test_auth_source[False] test_table_function_mongodb/test.py::test_complex_data_type[False] [gw1] [ 12%] PASSED test_table_function_mongodb/test.py::test_complex_data_type[False] test_table_function_mongodb/test.py::test_incorrect_data_type[False] [gw1] [ 16%] PASSED test_table_function_mongodb/test.py::test_incorrect_data_type[False] test_table_function_mongodb/test.py::test_missing_columns[False] [gw1] [ 20%] PASSED test_table_function_mongodb/test.py::test_missing_columns[False] test_table_function_mongodb/test.py::test_no_credentials[False] [gw1] [ 24%] PASSED test_table_function_mongodb/test.py::test_no_credentials[False] test_table_function_mongodb/test.py::test_predefined_connection_configuration[False] [gw1] [ 28%] PASSED test_table_function_mongodb/test.py::test_predefined_connection_configuration[False] test_table_function_mongodb/test.py::test_secure_connection[True] [gw3] [ 32%] PASSED test_storage_policies/test.py::test_storage_policy_configuration_change [gw0] [ 36%] PASSED test_storage_mysql/test.py::test_binary_type test_storage_mysql/test.py::test_enum_type [gw0] [ 40%] PASSED test_storage_mysql/test.py::test_enum_type test_storage_mysql/test.py::test_external_settings [gw1] [ 44%] PASSED test_table_function_mongodb/test.py::test_secure_connection[True] test_table_function_mongodb/test.py::test_simple_select[False] [gw0] [ 48%] PASSED test_storage_mysql/test.py::test_external_settings test_storage_mysql/test.py::test_insert_on_duplicate_select [gw0] [ 52%] PASSED test_storage_mysql/test.py::test_insert_on_duplicate_select test_storage_mysql/test.py::test_insert_select [gw0] [ 56%] PASSED test_storage_mysql/test.py::test_insert_select test_storage_mysql/test.py::test_many_connections [gw0] [ 60%] PASSED test_storage_mysql/test.py::test_many_connections test_storage_mysql/test.py::test_mysql_distributed [gw0] [ 64%] PASSED test_storage_mysql/test.py::test_mysql_distributed test_storage_mysql/test.py::test_mysql_in [gw0] [ 68%] PASSED test_storage_mysql/test.py::test_mysql_in test_storage_mysql/test.py::test_mysql_null [gw0] [ 72%] PASSED test_storage_mysql/test.py::test_mysql_null test_storage_mysql/test.py::test_predefined_connection_configuration [gw0] [ 76%] PASSED test_storage_mysql/test.py::test_predefined_connection_configuration test_storage_mysql/test.py::test_replace_select [gw0] [ 80%] PASSED test_storage_mysql/test.py::test_replace_select test_storage_mysql/test.py::test_settings [gw0] [ 84%] PASSED test_storage_mysql/test.py::test_settings test_storage_mysql/test.py::test_settings_connection_wait_timeout [gw0] [ 88%] PASSED test_storage_mysql/test.py::test_settings_connection_wait_timeout test_storage_mysql/test.py::test_table_function [gw0] [ 92%] PASSED test_storage_mysql/test.py::test_table_function test_storage_mysql/test.py::test_where [gw0] [ 96%] PASSED test_storage_mysql/test.py::test_where [gw1] [100%] PASSED test_table_function_mongodb/test.py::test_simple_select[False] =============================== warnings summary =============================== test_table_function_mongodb/test.py::test_auth_source[False] test_table_function_mongodb/test.py::test_secure_connection[True] test_table_function_mongodb/test.py::test_simple_select[False] /ClickHouse/tests/integration/helpers/cluster.py:2333: DeprecationWarning: database_names is deprecated. Use list_database_names instead. logging.debug(f"Connected to Mongo dbs: {connection.database_names()}") test_table_function_mongodb/test.py::test_auth_source[False] /ClickHouse/tests/integration/test_table_function_mongodb/test.py:226: DeprecationWarning: add_user is deprecated and will be removed in PyMongo 4.0. Use db.command with createUser or updateUser instead admin_db.add_user( test_table_function_mongodb/test.py::test_complex_data_type[False] /ClickHouse/tests/integration/test_table_function_mongodb/test.py:88: DeprecationWarning: add_user is deprecated and will be removed in PyMongo 4.0. Use db.command with createUser or updateUser instead db.add_user("root", "clickhouse") test_table_function_mongodb/test.py::test_complex_data_type[False] test_table_function_mongodb/test.py::test_secure_connection[True] test_table_function_mongodb/test.py::test_simple_select[False] /usr/local/lib/python3.8/dist-packages/pymongo/database.py:1247: DeprecationWarning: Creating a user with the read_only option or without roles is deprecated in MongoDB >= 2.6 warnings.warn("Creating a user with the read_only option " test_table_function_mongodb/test.py::test_incorrect_data_type[False] /ClickHouse/tests/integration/test_table_function_mongodb/test.py:123: DeprecationWarning: add_user is deprecated and will be removed in PyMongo 4.0. Use db.command with createUser or updateUser instead db.add_user("root", "clickhouse") test_table_function_mongodb/test.py::test_missing_columns[False] /ClickHouse/tests/integration/test_table_function_mongodb/test.py:262: DeprecationWarning: add_user is deprecated and will be removed in PyMongo 4.0. Use db.command with createUser or updateUser instead db.add_user("root", "clickhouse") test_table_function_mongodb/test.py::test_predefined_connection_configuration[False] /ClickHouse/tests/integration/test_table_function_mongodb/test.py:185: DeprecationWarning: add_user is deprecated and will be removed in PyMongo 4.0. Use db.command with createUser or updateUser instead db.add_user("root", "clickhouse") test_table_function_mongodb/test.py::test_secure_connection[True] /ClickHouse/tests/integration/test_table_function_mongodb/test.py:144: DeprecationWarning: add_user is deprecated and will be removed in PyMongo 4.0. Use db.command with createUser or updateUser instead db.add_user("root", "clickhouse") test_table_function_mongodb/test.py::test_simple_select[False] /ClickHouse/tests/integration/test_table_function_mongodb/test.py:46: DeprecationWarning: add_user is deprecated and will be removed in PyMongo 4.0. Use db.command with createUser or updateUser instead db.add_user("root", "clickhouse") -- Docs: https://docs.pytest.org/en/stable/how-to/capture-warnings.html ============================== slowest durations =============================== 43.15s setup test_storage_mysql/test.py::test_binary_type 21.95s call test_table_function_mongodb/test.py::test_simple_select[False] 21.89s setup test_table_function_mongodb/test.py::test_secure_connection[True] 21.78s setup test_table_function_mongodb/test.py::test_simple_select[False] 19.38s setup test_table_function_mongodb/test.py::test_auth_source[False] 15.38s setup test_storage_policies/test.py::test_storage_policy_configuration_change 15.14s setup test_temporary_data_in_cache/test.py::test_cache_evicted_by_temporary_data 10.89s call test_storage_policies/test.py::test_storage_policy_configuration_change 10.72s call test_storage_mysql/test.py::test_settings_connection_wait_timeout 7.41s teardown test_storage_mysql/test.py::test_where 4.46s call test_storage_mysql/test.py::test_mysql_distributed 3.11s teardown test_temporary_data_in_cache/test.py::test_cache_evicted_by_temporary_data 3.05s teardown test_table_function_mongodb/test.py::test_simple_select[False] 2.91s call test_storage_mysql/test.py::test_predefined_connection_configuration 2.85s call test_temporary_data_in_cache/test.py::test_cache_evicted_by_temporary_data 1.68s call test_storage_mysql/test.py::test_where 1.63s call test_storage_mysql/test.py::test_external_settings 1.57s call test_storage_mysql/test.py::test_settings 1.44s call test_storage_mysql/test.py::test_table_function 1.43s teardown test_storage_policies/test.py::test_storage_policy_configuration_change 1.33s call test_storage_mysql/test.py::test_replace_select 1.28s call test_storage_mysql/test.py::test_insert_on_duplicate_select 1.19s call test_storage_mysql/test.py::test_mysql_in 1.01s call test_table_function_mongodb/test.py::test_secure_connection[True] 1.00s call test_storage_mysql/test.py::test_insert_select 0.86s call test_storage_mysql/test.py::test_mysql_null 0.79s call test_storage_mysql/test.py::test_many_connections 0.71s call test_table_function_mongodb/test.py::test_complex_data_type[False] 0.69s call test_storage_mysql/test.py::test_enum_type 0.49s call test_table_function_mongodb/test.py::test_auth_source[False] 0.34s call test_storage_mysql/test.py::test_binary_type 0.32s call test_table_function_mongodb/test.py::test_missing_columns[False] 0.26s call test_table_function_mongodb/test.py::test_predefined_connection_configuration[False] 0.22s call test_table_function_mongodb/test.py::test_incorrect_data_type[False] 0.18s call test_table_function_mongodb/test.py::test_no_credentials[False] 0.00s teardown test_storage_mysql/test.py::test_binary_type 0.00s setup test_storage_mysql/test.py::test_where 0.00s teardown test_table_function_mongodb/test.py::test_secure_connection[True] 0.00s teardown test_table_function_mongodb/test.py::test_auth_source[False] 0.00s setup test_table_function_mongodb/test.py::test_missing_columns[False] 0.00s setup test_storage_mysql/test.py::test_many_connections 0.00s setup test_table_function_mongodb/test.py::test_no_credentials[False] 0.00s teardown test_storage_mysql/test.py::test_insert_select 0.00s teardown test_storage_mysql/test.py::test_replace_select 0.00s teardown test_storage_mysql/test.py::test_mysql_in 0.00s setup test_table_function_mongodb/test.py::test_predefined_connection_configuration[False] 0.00s setup test_table_function_mongodb/test.py::test_complex_data_type[False] 0.00s setup test_storage_mysql/test.py::test_mysql_in 0.00s setup test_storage_mysql/test.py::test_mysql_null 0.00s setup test_storage_mysql/test.py::test_table_function 0.00s teardown test_storage_mysql/test.py::test_many_connections 0.00s teardown test_storage_mysql/test.py::test_mysql_null 0.00s setup test_storage_mysql/test.py::test_replace_select 0.00s setup test_table_function_mongodb/test.py::test_incorrect_data_type[False] 0.00s setup test_storage_mysql/test.py::test_external_settings 0.00s teardown test_storage_mysql/test.py::test_table_function 0.00s teardown test_table_function_mongodb/test.py::test_incorrect_data_type[False] 0.00s setup test_storage_mysql/test.py::test_predefined_connection_configuration 0.00s setup test_storage_mysql/test.py::test_insert_select 0.00s setup test_storage_mysql/test.py::test_mysql_distributed 0.00s setup test_storage_mysql/test.py::test_enum_type 0.00s teardown test_storage_mysql/test.py::test_insert_on_duplicate_select 0.00s teardown test_storage_mysql/test.py::test_enum_type 0.00s setup test_storage_mysql/test.py::test_insert_on_duplicate_select 0.00s setup test_storage_mysql/test.py::test_settings_connection_wait_timeout 0.00s setup test_storage_mysql/test.py::test_settings 0.00s teardown test_storage_mysql/test.py::test_predefined_connection_configuration 0.00s teardown test_storage_mysql/test.py::test_external_settings 0.00s teardown test_table_function_mongodb/test.py::test_missing_columns[False] 0.00s teardown test_table_function_mongodb/test.py::test_complex_data_type[False] 0.00s teardown test_storage_mysql/test.py::test_settings_connection_wait_timeout 0.00s teardown test_table_function_mongodb/test.py::test_no_credentials[False] 0.00s teardown test_storage_mysql/test.py::test_settings 0.00s teardown test_storage_mysql/test.py::test_mysql_distributed 0.00s teardown test_table_function_mongodb/test.py::test_predefined_connection_configuration[False] =========================== short test summary info ============================ PASSED test_temporary_data_in_cache/test.py::test_cache_evicted_by_temporary_data PASSED test_table_function_mongodb/test.py::test_auth_source[False] PASSED test_table_function_mongodb/test.py::test_complex_data_type[False] PASSED test_table_function_mongodb/test.py::test_incorrect_data_type[False] PASSED test_table_function_mongodb/test.py::test_missing_columns[False] PASSED test_table_function_mongodb/test.py::test_no_credentials[False] PASSED test_table_function_mongodb/test.py::test_predefined_connection_configuration[False] PASSED test_storage_policies/test.py::test_storage_policy_configuration_change PASSED test_storage_mysql/test.py::test_binary_type PASSED test_storage_mysql/test.py::test_enum_type PASSED test_table_function_mongodb/test.py::test_secure_connection[True] PASSED test_storage_mysql/test.py::test_external_settings PASSED test_storage_mysql/test.py::test_insert_on_duplicate_select PASSED test_storage_mysql/test.py::test_insert_select PASSED test_storage_mysql/test.py::test_many_connections PASSED test_storage_mysql/test.py::test_mysql_distributed PASSED test_storage_mysql/test.py::test_mysql_in PASSED test_storage_mysql/test.py::test_mysql_null PASSED test_storage_mysql/test.py::test_predefined_connection_configuration PASSED test_storage_mysql/test.py::test_replace_select PASSED test_storage_mysql/test.py::test_settings PASSED test_storage_mysql/test.py::test_settings_connection_wait_timeout PASSED test_storage_mysql/test.py::test_table_function PASSED test_storage_mysql/test.py::test_where PASSED test_table_function_mongodb/test.py::test_simple_select[False] ================== 25 passed, 13 warnings in 92.48s (0:01:32) ==================